Variables
Your expression can contain any of the variables (which will be replaced during runtime) described in the table below.
General variables
| Variable Name | Description | Data Type |
|---|---|---|
|
AR_V_HOST_NAME |
The host name of the machine on which Qlik Replicate Server is installed. |
STRING (50) |
|
AR_V_SOURCE_NAME |
The logical name of the source endpoint defined in the endpoint settings. |
STRING (50) |
| AR_V_ERROR_TEXT | The error message returned by the task | STRING |
|
AR_V_TARGET_NAME |
The logical name of the target endpoint defined in the endpoint settings. |
STRING (50) |
|
AR_V_TASK_NAME |
The task name. |
STRING (50) |
|
AR_V_TASK_UUID |
A unique string (Universal Unique Identifier) that identifies the task. |
STRING (50) |
|
AR_V_RELOAD_TIME |
The time the source tables were reloaded. |
DATETIME (6) |
|
AR_V_START_TIME |
The time the task started. |
DATETIME (6) |
Notification variables
| Variable Name | Description | Data Type | Usage example |
|---|---|---|---|
|
AR_V_NOTIFY_IGNORE_COUNT |
The number of times to ignore the error before sending a notification. |
INT4 |
$AR_V_NOTIFY_IGNORE_COUNT < 5 Suppress the first five notifications triggered by the error. |
| AR_V_ERROR_TEXT | The error message returned by the task | STRING |
$AR_V_ERROR_TEXT ='Task ''Oracle2Oracle'' encountered a recoverable error' Suppress the notification if the error text matches the specified string. |
|
AR_V_HOST_NAME |
The host name of the machine on which Qlik Replicate server is installed. |
STRING (50) |
$AR_V_HOST_NAME = 'ak2022a.qa.int' Suppress the notification if the host name matches the specified string. |
|
AR_V_TASK_NAME |
The task name. |
STRING (50) |
$AR_V_TASK_NAME = 'Oracle2Oracle' Suppress the notification if the task name matches the specified string. |
|
AR_V_NOTIFY_LAST_TIME |
The time the last notification was sent (in epoch format). |
INT8 |
$AR_V_NOTIFY_LAST_TIME + 3600 > CAST(strftime('%s', 'now') AS INTEGER) If a notification is sent at the current time, suppress any subsequent notifications for an hour. |
|
AR_V_NOTIFY_MAX_RETRY |
The maximum number of times the task can be retried before failing. |
INT4 |
$AR_V_NOTIFY_ MAX_RETRY > AR_V_NOTIFY_NTH_RETRY_ONLY Suppress the notification until the last attempt to retry the task. |
|
AR_V_NOTIFY_NTH_RETRY_ONLY |
The current retry number (e.g. 5 out of 6) after a recoverable error. |
INT4 |
$AR_V_NOTIFY_NTH_RETRY_ONLY < 5 Suppress the notification until the sixth attempt to recover the task. |
Notification variables
| Variable Name | Description | Data Type | Usage example |
|---|---|---|---|
|
AR_V_NOTIFY_IGNORE_COUNT |
The number of times to ignore the error before sending a notification. |
INT4 |
$AR_V_NOTIFY_IGNORE_COUNT < 5 Suppress the first five notifications triggered by the error. |
| AR_V_ERROR_TEXT | The error message returned by the task | STRING |
$AR_V_ERROR_TEXT ='Task ''Oracle2Oracle'' encountered a recoverable error' Suppress the notification if the error text matches the specified string. |
|
AR_V_HOST_NAME |
The host name of the machine on which Qlik Replicate server is installed. |
STRING (50) |
$AR_V_HOST_NAME = 'ak2022a.qa.int' Suppress the notification if the host name matches the specified string. |
|
AR_V_TASK_NAME |
The task name. |
STRING (50) |
$AR_V_TASK_NAME = 'Oracle2Oracle' Suppress the notification if the task name matches the specified string. |
|
AR_V_NOTIFY_LAST_TIME |
The time the last notification was sent (in epoch format). |
INT8 |
$AR_V_NOTIFY_LAST_TIME + 3600 > CAST(strftime('%s', 'now') AS INTEGER) If a notification is sent at the current time, suppress any subsequent notifications for an hour. |
|
AR_V_NOTIFY_MAX_RETRY |
The maximum number of times the task can be retried before failing. |
INT4 |
$AR_V_NOTIFY_ MAX_RETRY > AR_V_NOTIFY_NTH_RETRY_ONLY Suppress the notification until the last attempt to retry the task. |
|
AR_V_NOTIFY_NTH_RETRY_ONLY |
The current retry number (e.g. 5 out of 6) after a recoverable error. |
INT4 |
$AR_V_NOTIFY_NTH_RETRY_ONLY < 5 Suppress the notification until the sixth attempt to recover the task. |